The application of the NON EMPTY clause, alters the query from returning all members, to just returning those that have measure values. NONEMPTY子句的应用将查询从返回所有成员修改为仅返回具有度量值的那些成员。
Usage: This parameter controls the decision on whether or not to apply a NON EMPTY clause on member requests when the number of tuples exceeds the set threshold. 用法:当元组数超过设定的阈值时,该参数控制是否对成员请求应用NONEMPTY子句的决策。
Applying the NON EMPTY clause allows the MDX to only return members that have measure data. 应用NONEMPTY子句允许MDX仅返回具有度量数据的成员。
Usage: This parameter controls the decision on when the NON EMPTY clause is applied to the query MDX. 用法:该参数控制何时向查询MDX应用NONEMPTY子句的决策。
If the number of tuples, calculated by using the Cartesian product, exceeds the set threshold; the NON EMPTY clause is applied to the query. 如果通过使用Cartesian产品计算的元组数超过设定的阈值,将NONEMPTY子句应用于查询。